package cn.xorange.commons.core.annotation.aspect;

import cn.xorange.commons.core.annotation.DataScope;
import cn.xorange.commons.data.core.entity.BaseEntity;
import cn.xorange.commons.security.context.SecurityContextHolder;
import cn.xorange.commons.security.entity.SecurityRole;
import cn.xorange.commons.security.entity.SecurityUser;
import cn.xorange.commons.security.service.SecurityService;
import cn.xorange.commons.utils.Collect.CollectUtils;
import cn.xorange.commons.utils.lang.ObjectUtils;
import cn.xorange.commons.utils.lang.StringUtils;
import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.annotation.Aspect;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
import java.util.Objects;

/**
 * @author : yangjian
 * date : 2024/7/30
 * description :
 */
//@Aspect
//@Component
public class DataScopeAspectBack {


    @Resource
    SecurityService securityService;

    /**
     * 全部数据权限
     */
    public static final String DATA_SCOPE_ALL = "1";

    /**
     * 自定数据权限
     */
    public static final String DATA_SCOPE_CUSTOM = "2";

    /**
     * 部门数据权限
     */
    public static final String DATA_SCOPE_DEPT = "3";

    /**
     * 部门及以下数据权限
     */
    public static final String DATA_SCOPE_DEPT_AND_CHILD = "4";

    /**
     * 仅本人数据权限
     */
    public static final String DATA_SCOPE_SELF = "5";

    /**
     * 数据权限过滤关键字
     */
    public static final String DATA_SCOPE = "dataScope";


    protected void handleDataScope(final JoinPoint joinPoint, DataScope dataScope) {
        SecurityUser user = securityService.getLoginUser();
        if(Objects.nonNull(user)){
            if(!user.getIsAdmin()){
                String permission = org.apache.commons.lang3.StringUtils.defaultIfEmpty(dataScope.permission(), SecurityContextHolder.getContext());
                dataScopeFilter(joinPoint, user, dataScope.orgAlias(),
                        dataScope.userAlias(), permission);
            }
        }
    }

    /**
     * 数据范围过滤
     *
     * @param joinPoint 切点
     * @param user 用户
     * @param deptAlias 部门别名
     * @param userAlias 用户别名
     * @param permission 权限字符
     */
    public static void dataScopeFilter(JoinPoint joinPoint, SecurityUser user, String deptAlias, String userAlias, String permission)
    {
        StringBuilder sqlString = new StringBuilder();
        List<String> conditions = new ArrayList<>();

        String[] permissionArr = StringUtils.toArray(permission,",");



        for (SecurityRole role : user.getRoles())
        {
            String dataScope = role.getDataScope();
            if (conditions.contains(dataScope))
            {
                continue;
            }
            if (!CollectUtils.containsAny(user.getPermissions(), permissionArr))
            {
                continue;
            }
            if (DATA_SCOPE_ALL.equals(dataScope))
            {
                conditions.add(dataScope);
                break;
            }
            else if (DATA_SCOPE_CUSTOM.equals(dataScope)) {
                List<String> scopeCustomIds = new ArrayList<>();
                user.getRoles().forEach(r -> {
                    if (DATA_SCOPE_CUSTOM.equals(r.getDataScope()) && CollectUtils.containsAny(user.getPermissions(), permissionArr)) {
                        scopeCustomIds.add(ObjectUtils.toString(r.getRoleId()));
                    }
                });

                if (scopeCustomIds.size() > 1) {
                    // 多个自定数据权限使用in查询，避免多次拼接。
                    sqlString.append(StringUtils.format(" OR {}.org_id IN ( SELECT org_id FROM sys_role_org WHERE role_id in ({}) ) ", deptAlias, String.join(",", scopeCustomIds)));
                }
                else
                {
                    sqlString.append(StringUtils.format(" OR {}.org_id IN ( SELECT org_id FROM sys_role_org WHERE role_id = {} ) ", deptAlias, role.getRoleId()));
                }
            }
            else if (DATA_SCOPE_DEPT.equals(dataScope))
            {
                sqlString.append(StringUtils.format(" OR {}.org_id = {} ", deptAlias, user.getOrgId()));
            }
            else if (DATA_SCOPE_DEPT_AND_CHILD.equals(dataScope))
            {
                sqlString.append(StringUtils.format(" OR {}.org_id IN ( SELECT org_id FROM sys_org WHERE org_id = {} or find_in_set( {} , ancestors ) )", deptAlias, user.getOrgId(), user.getOrgId()));
            }
            else if (DATA_SCOPE_SELF.equals(dataScope))
            {
                if (!StringUtils.isEmpty(userAlias)) {
                    sqlString.append(StringUtils.format(" OR {}.user_id = {} ", userAlias, user.getUserId()));
                }
                else {
                    // 数据权限为仅本人且没有userAlias别名不查询任何数据
                    sqlString.append(StringUtils.format(" OR {}.org_id = 0 ", deptAlias));
                }
            }
            conditions.add(dataScope);
        }

        // 角色都不包含传递过来的权限字符，这个时候sqlString也会为空，所以要限制一下,不查询任何数据
        if (conditions.isEmpty())
        {
            sqlString.append(StringUtils.format(" OR {}.org_id = 0 ", deptAlias));
        }

        if (sqlString.length()>0)
        {
            Object params = joinPoint.getArgs()[0];
            if (Objects.nonNull(params) && params instanceof BaseEntity)
            {
                BaseEntity baseEntity = (BaseEntity) params;
                baseEntity.getParams().put(DATA_SCOPE, " AND (" + sqlString.substring(4) + ")");
            }
        }
    }


    /**
     * 拼接权限sql前先清空params.dataScope参数防止注入
     */
    private void clearDataScope(final JoinPoint joinPoint)
    {
        Object params = joinPoint.getArgs()[0];
        if(Objects.nonNull(params) && params instanceof BaseEntity){
            BaseEntity baseEntity = (BaseEntity) params;
            baseEntity.getParams().put(DATA_SCOPE, "");
        }
    }

}
